package com.igeekhome.wzgl.mapper;

import com.igeekhome.wzgl.entity.MaterialsledgerEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
@Mapper
public interface IMaterialsledgeMapper {
    @Select("SELECT * from material_ledger")
    List<MaterialsledgerEntity> page();
    @Select("select * from material_ledger where material_brand=#{materialBrand}")
    List<MaterialsledgerEntity> brand(String materialBrand);
    @Select("select * from material_ledger where material_type=#{materialType}")
    List<MaterialsledgerEntity> type(String materialType);
    @Select("select * from material_ledger where material_model=#{materialModel}")
    List<MaterialsledgerEntity> model(String materialModel);

    @Select("select * from material_ledger where id=#{id}")
    List<MaterialsledgerEntity> select(int id);
}
